RE: [PHP-DB] Formatting Strings in MySQL

Artur- No problem. :-) Well, you could enter it with the spacing you want by using CHAR(11) instead of INT(9) or whatever in SQL. However, depending on how large of a DB this will be, and how many entries, that's not the optimal way to do it as you must store to more (null) bytes with every entry, and transfer 2 more (null) bytes out with every query. Sure, 2 bytes isn't very much, but I'm a stickler for smooth code. The less that NEEDS to be sent, moved or stored, the better. The amount of time it takes to format the query afterwards vs. the time it takes to poll those extra 2 bytes is logically the same, but it taxes the SQL those few bytes less *shrug* Either way will work most acceptably. Otherwise, no, I'm not aware of a command that will specifically format that way in MySQL. Jesse Williams System Administrator DowNET VoIP Team Electronic Data Systems -----Original Message----- From: Artur Correia [mailto:artur.correia@netvisao.pt] Sent: Monday, July 02, 2001 11:37 AM To: Jesse S. Williams Subject: Re: [PHP-DB] Formatting Strings in MySQL Hey, Thanks in advance for your trouble replying this. I havent tried it out yet - nor will I untill August. I'm still planning all this database before I start coding. This is going to be my first work using mysql/Apache/php4 (it's going to be a web based administration tool for a lawfirm (intranet). Anyway, it sounds good. As for the string - it's either NULL value or a 9 digit number (initially the idea was to format a social security number (in Portugal we have only 9 digits). Incidentally - i also thought of directly inputing the string formatted into mysql (I'd rather do this, actually). I've tried using the FORMAT (field,0) argument, but the output is always comm separated numbers like 123,123,123, and this isn't exactly what I had in mind. Do you know of a command in mysql (either to use with INSERT or SELECT) that can do this?? Thanks a lot Artur Correia Oliveira, Correia & Correia