Hi,
How can I display only certain occurences from my database based on a certain
critieria.
In the filed "strSelect" I could have a long string which would contain:
strSelect =
"D:\temp\file.txt,D:\temp\file2.txt,D:\mywork\file.txt,D:\mywork\file.txt,D:\documents\file.txt,D:\documents\file.txt"
So in my query I want to just display the match of "D:\mywork" and nothing else. Can
this be done in SQL?
<cfquery name="ListElement" datasource="user-profiles" dbtype="ODBC">
SELECT *
FROM profiles
WHERE strUsername = '#auth#'
</cfquery>
---------------------------------------------------
Colonel Nathan R. Jessop
Commanding Officer
Marine Ground Forces
Guatanamo Bay, Cuba
---------------------------------------------------
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
