Use like-commando

wxdqz

New Member
Hi,

My problem is, that I want to do this:

mysql_query("update mysql set user = 'q' where user like '%U%';

...BUT, it should be "user NOT like '%u%';" how can I do that?

I have tried:

- user not like '%u%'
- user nlike '%u%'
- user notlike '%u%'
- like user <> '%u%'
- user like <> '%u%'
 
Back
Top