MySQL query like initials problem

[freddylocks]

Hi Everyone.

I have a question regarding a Mysql query I am trying to run.

I have 2 tables.

Table 1: I have a column called FN which I hope to link to another table. At present the column uses two characters eg. Jo
Table 2: I have several columns, of which one is full name. eg John Smith.

As part of a PHP script, I am first doing a query on Table 1, and then depending on the output of the FN Column from table 1 to do an sql query (query=select * table2 where fullname LIKE jo%) on table 2.

This section works fine.
However, I am now wishing to change column FN to represent the initials of a name, eg JS
This is where the issue I am having comes in... how do I do an SQL query to look for the initials instead of the first two letters?

Thanks
Freddy

[ronverdonk]

I cannot see right now how you would handle all that in an SQL statement.

In my view, best thing to do would be to read in the initials field, split them into individual initials, and then use these characters to search in the data base.

After that you can use the first initial to select fields starting with that 1st initial and then, in PHP use the remaining initials to scan the fields retrieved.

Ronald :cool: