search a table which has a apostrophe in it

crmpicco · August 9th, 2005, 07:01 AM

Code:

SELECT * FROM `countryname` where CountryName like  '%'''%'

How do i search a table which has a apostrophe in it? I have tried the above, but it doesnt work.

My error is
Error: You have mismatched `'`

www.crmpicco.co.uk
www.crmpicco.co.uk.tt
www.milklemonadechocolate.uk.tt
www.griswolds.uk.tt
www.piccosmini.co.uk.tt
www.morton.uk.tt

happygv · August 9th, 2005, 03:27 PM

This is how it should be.

Code:

SELECT * FROM `dbo_tp_countryname` where CountryName like  '%\'%'

\ is the escape character in myssql.

Cheers

_________________________
- Vijay G
Strive for Perfection

crmpicco · August 10th, 2005, 06:23 AM

Code:

select * FROM airport LEFT JOIN airportname ON airport.airportcode=airportname.airportcode WHERE airportname.airportcode = ''
i have two tables airport and airportname.
airport has the airportcode KYO,
airportname doesnt.
I need to find what other airportcodes dont match up.
i.e. what airport codes are in airport but not airportname

The above syntax doesnt work.

airport TABLE STRUCTURE:
+-------------+--------------+----------+
| AirportCode | FacilityCode | CityCode |
+-------------+--------------+----------+
| AAA | A | AAA |
| AAB | A | AAB |
+-------------+--------------+----------+

airportname TABLE STRUCTURE:
+--------------+-------------+-------------------------------+
| LanguageCode | AirportCode | AirportName |
+--------------+-------------+-------------------------------+
| GB | AAA | Anaa |
| GB | AAB | Arrabury |
+--------------+-------------+-------------------------------+

Thanks.

Picco

www.crmpicco.co.uk
www.crmpicco.co.uk.tt
www.milklemonadechocolate.uk.tt
www.griswolds.uk.tt
www.piccosmini.co.uk.tt
www.morton.uk.tt