Thread: select .. like ignore case
Is there a way to issue select .. like to ignore letter case? Or do I have to use full text indexing? Regards, -- Marcin Gil marcin.gil @ audax.com.pl, tel. 694972082 OIS Audax Sp. z o.o., ul. Barlickiego 4, 97-200 Tomaszów Mazowiecki tel/fax (44) 7247530, 7244401
> Is there a way to issue select .. like to ignore letter case? **For example: select * from customers where upper(name) like '%JOHN%' > Or do I have to use full text indexing? **Full-text indexing is a whole other thing... Bye: MaFa
MaFa wrote: > select * from customers where upper(name) like '%JOHN%' Thanks. I found that >>select * from documents where body ~ some_text'<< also gives good results. I am only concerned about its effectiveness. > **Full-text indexing is a whole other thing... I've looked quite a bit at tsearch2.. too complicated for me for now. -- Marcin Gil marcin.gil @ audax.com.pl, tel. 694972082 OIS Audax Sp. z o.o., ul. Barlickiego 4, 97-200 Tomaszów Mazowiecki tel/fax (44) 7247530, 7244401
MaFa wrote: >>Is there a way to issue select .. like to ignore letter case? > > **For example: > select * from customers where upper(name) like '%JOHN%' > The other answer I received was: select ... ilike.. simple, eh? -- Marcin Gil :: marcin.gil@audax.com.pl OIS Audax Sp. z o.o., ul. Barlickiego 4, 97-200 Tomaszów Mazowiecki tel (44) 7247530 w/22, 7244401 w/22 -- fax w/25