MySQL LIKE statement

Question

Hi guys.

I have a SQL query SELECT * FROM table WHERE column LIKE '%pdd%'.

The problem is I need to get all results excluding those which start with "pdd", I mean find everything where "pdd" is not at the beginning. How could it be done?

Thank you.

UPD. Sorry, I should've clarified my question a little bit more. I do need to match "pdd" except at the beginning of the column.

Answer 1

Try:

SELECT * FROM table WHERE column NOT LIKE 'pdd%'

Answer 2

I assume you mean all rows that match "pdd" except those where "pdd" is at the beginning.

SELECT * FROM table WHERE column LIKE '_%pdd%'.

The "_" wildcard in LIKE predicates means "one of any character," equivalent to "." in regular expressions.

Answer 3

If I understand your requirement correctly what you need is:

SELECT * FROM table WHERE column LIKE '%pdd_%' and column NOT LIKE 'pdd_%'

Answer 4

SELECT * FROM table WHERE column LIKE '%pdd%' AND column NOT LIKE 'pdd%'

You can optimise the query depending on how frequent these occurrences are in your table.