Not signed in (Sign In)

Vanilla 1.1.4 is a product of Lussumo. More Information: Documentation, Community Support.


Archive: Query to match first name from full name

Bottom of Page

1 to 2 of 2

  1.  
    • CommentAuthorjustnajm
    • CommentTimeDec 11th 2006
     
    Hi,

    Have a column of actors full name, need to make a query for web users to make search on the basis of only first name or full name. Can I do this through query in mysql database, for e.g.

    full name is Jhony Ibraham

    can I retrieve his record with the first name only 'Jhony'

    SELECT * FROM actors WHERE name = 'Jhony';

    It do not retrieve any record

    SELECT * FROM actors WHERE name = 'Jhony Ibraham';

    this query do, but require exact and full name. Which will be hard for web users to remember or may they don't know the full name.

    Advance thanks for the query,

    Najm.
    • CommentAuthorjiosis
    • CommentTimeJan 30th 2007
     
    SELECT * FROM actors WHERE name LIKE 'Jhony%';

    I think !

1 to 2 of 2

  1.