Querying in Database help?????? (1 Viewer)

[th]

--------------------------------------------------------------------------------

how do u these in a query????


how do u find all people whose family name contains the letter "a"

 

[fatmuscle]

well, that would depend on your tables, fields, etc



after nearly failing my database s ubject, i don't even know why i'm attempting to help.


eg
SELECT 'first name', 'family name'
FROM 'whitepages'
WHERE 'family name' = *a*

hehhe, i have nfi about SQL

 

[Korn]

Also depends on where ur using this queyy and the query language used, also wouldnt it depend on the Database software be used

 

[fatmuscle]

yeah, i've forgotten all that integrity stuff.
and the naming conventions.

glad i was close and not way off.

 

[Pharaohsam]

basically, in the field for name where it asks you for the criteria just write "*a*" that should do it