View Full Version : Search string in database field
Is it possible to search for a particular string within a database field,
for example string = 'Program Finished' field name = 'Output'
if so how?
Any help would be good.
Thanks in advance.
02-13-2006, 05:36 PM
output LIKE '%Program Finished%'
The above will return all rows where the output column contains the string anywhere within it. The LIKE keyword indicates a non-exact search, and the '%' characters are wildcards that let the database know that there can be any number of unknown characters before or after the string you're searching for.
thanks for that, i'll have a go at it.
02-14-2006, 03:19 PM
Powered by vBulletin® Version 4.2.2 Copyright © 2017 vBulletin Solutions, Inc. All rights reserved.