LIKE related question

[786snow]

Is it possible to have OR with LIke, I am trying to do the following , whcih is obviously wrong as it is not working

select*  from products,  where category_id = 'ph100'  and features_camera LIKE '%2%' or '%3%'  order by auto_no desc LIMIT 0,10

 

[piti]

select* from products, where category_id = 'ph100' and features_camera LIKE '%2%' or features_camera LIKE '%3%' order by auto_no desc LIMIT 0,10

or use regular expressions

select* from products, where category_id = 'ph100' and features_camera RLIKE '[2|3]+'

 

[r937]

it's "wrong" because you forgot the parentheses...

select please
     , list
     , only
     , the
     , columns
     , you
     , need
  from products
 where category_id = 'ph100'  
   and [b][red]([/red][/b]
       features_camera LIKE '%2%' 
    or features_camera LIKE '%3%'
       [b][red])[/red][/b]
order 
    by auto_no desc LIMIT 0,10

r937.com | rudy.ca

 

[piti]

:-D yeah, thanks