I have a company name as follows: Chemistry & chemicals
I have plenty of those in my database which come with ampersands, now when i do a query i get nothing. How best can i write the query using a string with an ampersand as part of it. I am developing in a PHP/SQlite environment.