Re: MySQL and running a function similar to PATINDEX()

2003-06-16 Thread Don Read
On 16-Jun-2003 Tom Johnson wrote: > Is it possible to convert the following query to run in MySQL? The query > is > based on a table called "ardata" which contains the fields 'author', > 'lname', and 'fname'. The 'author' field contains the authors first and > last name with a space in the middl

MySQL and running a function similar to PATINDEX()

2003-06-16 Thread Tom Johnson
Is it possible to convert the following query to run in MySQL? The query is based on a table called "ardata" which contains the fields 'author', 'lname', and 'fname'. The 'author' field contains the authors first and last name with a space in the middle. I want to convert the names over so the f