Welcome to WebmasterWorld Guest from 220.127.116.11 , register , free tools , login , search , pro membership , help , library , announcements , recent posts , open posts Become a Pro Member
MySQL LIKE condition bysonary msg:3363903 12:38 am on Jun 11, 2007 (gmt 0) hey i have a question is it possible to combin the LIKE feature of mysql to construct a query that would be like this.
select * from table WHERE field LIKE 'chris' AND NOT LIKE 'chriostopher'
if you can could someone please tell me how?
Gibisan msg:3364007 3:18 am on Jun 11, 2007 (gmt 0)
You can combine LIKE in queries
select * from table WHERE field LIKE 'chris%' AND field NOT LIKE 'christopher%'
The above query will return every name beginning 'chris' but will not return names beginning 'christopher'
(I assumed you made a typo in your example with 'chriostopher')
bysonary msg:3365330 1:15 pm on Jun 12, 2007 (gmt 0)
yes i did make a typo, thats great, so you could i use this with numbers for example if a number field contains the number 1555 and 1556 if i exclude the 1556 will i get all of the records with 1555 in the field? barns101 msg:3365490 4:08 pm on Jun 12, 2007 (gmt 0)