I am running MySQL server 4.0.16 with MyISAM tables an a UTF-8 Default character
encoding in the tables.
Is it possible to make it so when a user enters a query using American English
characters that they will equate to similar European (and other characters). So if
they were to type a 'u' fo
I have a table called 'Journal_Info' containing titles of various journals
When searching and listing them I want to remove any preceeding 'The ', 'An ', or 'A '
that occurs in the title and I also want to be able to search it. The case statement
as follows seems to work fine:
SELECT
CASE
WH
I'm having tremendous problems with a query and I was hoping someone could point out
where (if) I'm going wrong.
Using MySQL 4.0.15 on a LINUX box.
Basically I have a database that lists a large number of web links cataloged by
subject.
The first table (records) contains all the link informat
