eric1328 Posted November 2, 2008 Share Posted November 2, 2008 Hi, I'm new to MySQL and i'm trying to figure out if i can do something like: select x from xy where xyz='?' and abc=TRIM(LEADING '@' FROM 'pre@test') This syntax isn't working for me; what's the correct way to use a TRIM function like this? Instead of pre@test, i'm actually going to use a variable...thats why i want the trim. Thanks for your help! Eric Link to comment https://forums.phpfreaks.com/topic/131103-use-trim-function-following-where-in-select-statement/ Share on other sites More sharing options...
fenway Posted November 3, 2008 Share Posted November 3, 2008 That '@' sign isn't leading.... Link to comment https://forums.phpfreaks.com/topic/131103-use-trim-function-following-where-in-select-statement/#findComment-681451 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.