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 Quote 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.... Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.